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. 🙂
yeah, right. Do the project columns have random names or are the always called Project1-5?
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. 🙂
perfect, have a nice day!