mikansang
New Member
- Joined
- Jan 22, 2020
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
Hi all,
I am trying to automate a process which requires a daily summary of information that is sent to me in multiple tables of varying length on a day to day basis (see picture).
Currently we have to move the information we want from each column into a separate tab manually and then apply the "Store title" at the top of each table as a new column so that the information is summarised in one table and the store name is there for each row. This is because I can't put this info in a pivot table straight away because the store names are at the top.
In addition this is minor but I have to create one more new column which uses todays date and column 6 data which is a date. Which I found out you can't do in a pivot table >.<
Any ideas how I could do this?
I am trying to automate a process which requires a daily summary of information that is sent to me in multiple tables of varying length on a day to day basis (see picture).
Currently we have to move the information we want from each column into a separate tab manually and then apply the "Store title" at the top of each table as a new column so that the information is summarised in one table and the store name is there for each row. This is because I can't put this info in a pivot table straight away because the store names are at the top.
In addition this is minor but I have to create one more new column which uses todays date and column 6 data which is a date. Which I found out you can't do in a pivot table >.<
Any ideas how I could do this?
