I want to re-arrange the data in same excel sheet. The data have a column Period Date with dates in it and corresponding ROAA Values. I want to rearrange the ROAA values on the basis of Quarters columns picked from Period Date Column.
So that i can have ROAA values on the basis of Quarter and can delete duplicate rows and can have data of one bank in one row only.
I tried using formulas and managed to populate data quarterly, but need help in populating the same bank data in one row only and deleting the rest duplicate rows.
CodePudding user response:
Use Pivot Tables to resume your data:
I took field Issuer Name
into rows section, field Value
into Values section and Date
into Columns Section.
Note I created a group in the date field, grouping by year and quarter.
Pivot Tables is your best option here, because if you add new rows to your table, you just need to update your Pivot Table and it will rearrange everything.