excel - Group columns into new columns -


i have table:

id|cola1|cola2|colb1|colb2 01|aaaaa|bbbbb|ccccc|ddddd 02|eeeee|fffff|ggggg|hhhhh 

or column order like:

id|cola1|colb1|colb2|cola2 01|aaaaa|ccccc|ddddd|bbbbb 02|eeeee|ggggg|hhhhh|fffff 

i want rearrange this:

id|     |cola |colb 01|cola1|aaaaa|ccccc 01|cola2|bbbbb|ddddd 02|cola1|eeeee|ggggg 02|cola2|fffff|hhhhh 

yes know id not unique. can see, cola's grouped new column, , colb's grouped column.

is possible powerpivot?


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

How to understand 2 main() functions after using uftrace to profile the C++ program? -