Hi excel community,
It’s finally the point in my life where I realised how powerful but painful excel can be and would like to learn more.
As the attached table, I have a simple pivot table stating the names on the first column, and the dates of testing of the second column. For some names, there are multiple dates of testing (e.g in row 5, the name has 2 dates of testing 2021115 and 20211118) I would like the table to show only one date in each column (e.g in row 5, the 20211118 date should be in column C instead of grouped together in column B)
Is that possible? Thank you.
It’s finally the point in my life where I realised how powerful but painful excel can be and would like to learn more.
As the attached table, I have a simple pivot table stating the names on the first column, and the dates of testing of the second column. For some names, there are multiple dates of testing (e.g in row 5, the name has 2 dates of testing 2021115 and 20211118) I would like the table to show only one date in each column (e.g in row 5, the 20211118 date should be in column C instead of grouped together in column B)
Is that possible? Thank you.