Forum Discussion
Transform table to additional rows
Hi There, I have a table that I need to transform into a proper table. I'm developing a timesheet table based on MS Forms output. User can input up to 5 projects. Each project is housed in 1 column,...
It's OK. I manage to solve it, but in a round about way:
1. Merge Column Project & Hour with delimiter, resulting in 3 new columns
2. Unpivot, then you'll only have 1 value of Attribute, which is the Column from #1
3. Split the Value column with delimiter
With this I have the columns that I want. 🙂
Hi,
I try to unpivot, but it gaves a half solution. How should I transpose the attribute & value, but only to 2 columns while retaining to the Name & Date column?