Text to Columns (Even rows)

[YXM1012]

I have a database with 3 columns (No. of records, SKU ID and Price). I noticed that all the odd rows have the information, but in the even rows, I have the "Product Name". So I would like to find a solution to convert the even rows as a column of the odd rows.

Input:

Output

Thanks for your support!

[AngelosPachis · Accepted solution]

Hi @YXM1012 ,

Here is one way to do it

Hope that helps,

Angelos

[YXM1012]

Many thanks for helping me! 🙂