Below I have a table I would like to transform into my second table. The idea is that the row with numbers in col 2 and col 3 is the main row and the rows below that row with null values in col 2 and col 3 belong to that same group. So in my example there are three groups, the rows below the groups I would like to have them as column values, note the column names does not matter. How can I achieve my desired results? Thanks in advance!
Original table:
Col 1 | Col 2 | Col 3 |
MISC PAYMENT | 567 | 56789 |
Org | [Null] | [Null] |
CREDIT | 123 | 12345 |
XO | [Null] | [Null] |
AX | [Null] | [Null] |
CREDIT | 780 | 123456 |
ABC | [Null] | [Null] |
MC | [Null] | [Null] |
Desired results:
Col 1 | Col 2 | Col 3 | Col 4 | Col 5 |
MISC PAYMENT | 567 | 56789 | Org | |
CREDIT | 123 | 12345 | XO | AX |
CREDIT | 780 | 123456 | ABC | MC |
@overhead_press not the prettiest workflow but it gets the job done (I think :))
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |