Hi folks,
I frequently get data in column format that I need to convert to a table. For example, I get a single column of data like this:
Tom
1
2
3
****
4
5
6
Harry
7
8
9
I want it in the following form:
Name C1 C2 C3
Tom 1 2 3
**** 4 5 6
Harry 7 8 9
Historically, I convert the column data to table form using (1) the offset function, or (2) Microsoft Word's text-to-table function. I am now using Power Query, which I like very much, but I do not know how to do this conversion in PQ. Any ideas?
Zig
I frequently get data in column format that I need to convert to a table. For example, I get a single column of data like this:
Tom
1
2
3
****
4
5
6
Harry
7
8
9
I want it in the following form:
Name C1 C2 C3
Tom 1 2 3
**** 4 5 6
Harry 7 8 9
Historically, I convert the column data to table form using (1) the offset function, or (2) Microsoft Word's text-to-table function. I am now using Power Query, which I like very much, but I do not know how to do this conversion in PQ. Any ideas?
Zig