How to transform excel text list to table

Hi Murat62,

I'm not sure if I get this straight, but based on what you had said, my understanding is the following:

The category column (named Column) is recursive, and whenever the sequence starts from the beginning (with "A" value), the record number increases with 1. 

So, based on it, I don't know if there's any solution in the Power Query for that matter, but I figured out a way in Excel: if you create a new column with the following formula, you'll get the record numbers:

=IFERROR(IF(A1>A2;C1+1;C1);1)

If you load this table into PBI, you can create the pivot table in the Power Query you wanted. (with Column From Examples or even in Excel with the concatenate formula you can get the "record 1", "record 2"... format easily)

Let me know please if it solves your problem and whether it was helpful or not.

Best regards,

Andris