Remove nulls and move values up to one line

[Anonymous]

Hi everyone!
Yesterday a kind user helped me to transform every 4 rows into columns. 
But now I have to move up all the info of those columns up - remove nulls and transform the info to a line.

Please see the pic below:

For example, the first line would be 1234 / xyz / id / may-20

How can I do that?
I've tried to filter, but the other columns disappear. 
Also tried to fill up but I couldn't - I'm a newbie user..lol

Any tips? If so, would be great to know where to put the strings, etc... lol 😄

Thanks a lot! (L)

[edugoncalves]

@MFelix
In fact, this solution is much more straight and scalable than what I proposed.
Thanks for sharing, Miguel!

[MFelix · Accepted solution]

Hi @Anonymous ,

I went back to your initial post and believe that the solution provided by @edugoncalves  is not the best one, you can perform this without adding a column for each one and get a value per row.

Do the following:

• On your original data add a Index Column

• Add a custom column with the following syntax:

if [#" Column2"] = "Group" then [Index] else null

Use the name of the first value of your data in the IF part in this case you refer that is group.

• Do a fill down on the nem column:

• Remove Index Column
• Do a Pivot by column two values without aggregating the column 1

Now you can delete the custom column.

@edugoncalves sorry for giving an option on top of yours but believe is much easier and effecient.

PBIX file attach.

[Anonymous]

Great solution too, MFelix!
Thanks for that! I've tested too and worked fine!
Thanks a lot!