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! 😀
One more thing, edugoncalves ...
I'm trying to remove the null's with your tip but I couldn't...lol
I have to put the Fill up and down after the code to add custom? I've tried shift + enter but returns me an error ....I could only fill down the first collumn but not the others 😞
BTW, edugoncalves in my original file I have 7 columns