Forum Discussion
Convert every 6 rows into columns
Hi guys! Can anyone help me? I have around 7.000 lines with data - a XML file. Every 4 rows the "block" starts again. It's always "group, name, number, data" Something like this: Column1 -...
Brazil is great, I'm helping you from Portugal! 😀
Sorry if I skipped some detailed steps...
You need to go here:
After that, write the following code (for each column you gonna need), adapting your if-statement to each column.
E.g.:
Column Name = if [Column 2] = "Name" then [Column 1] else null Column Id = if [Column 2] = "Id" then [Column 1] else null ...Um abraço! 😀
Thanks a lot! 🙂 🙂 Worked fine!! 😁