#1
|
|||
|
|||
Help switch rows to columns based on criteruim
I need help to convert the rows from the table above to the columns as in the table below (all data for one man). Is there any way to convert the rows to the columns.
Thank in andvanced |
#2
|
|||
|
|||
Something like this?
Columns with colored headers on Datasheet sheet are calculated! You enter/select only Number, Absence type, and Days. PS: Remove last column on Persons sheet! I forgot deleting it before posting! |
#3
|
||||
|
||||
Very straightforward in Power Query.
See green table in attached and to update, right-click it and choose Refresh. |
#4
|
|||
|
|||
Help switch rows to columns based on criteruim
Thank you very much
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete blank table rows in merged document and split document in docx and pdf based on excel rows | Alex1s85 | Word VBA | 5 | 05-22-2021 12:05 PM |
Transposing Columns and Rows in | skeezix | Excel | 8 | 04-30-2020 08:23 PM |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
Stack columns into rows | stellag09 | Excel | 1 | 04-23-2014 03:26 AM |
Rows to Columns | kyakobi | Excel | 5 | 12-07-2010 03:12 PM |