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!

Test.xlsx

AngelosPachis

Hi @YXM1012 ,

Here is one way to do it

Hope that helps,

Angelos

example.yxmd