I was wondering if you could help with an excel issue I am having.
Essentially, I have an excel sheet with some data. I would like to insert a new column and concatenate the data from two already existing columns. Once that is done, insert a pivot table based on the data from the concatenated column. I have tried recording (basic) but that didn’t work properly. I read through some of the other solutions provided to some similar questions but was not able to tailor the latter to my data.
The process is as follows:
(1) Open excel
(2) Go to a certain tab and click a button that will generate a pivot table of numbers. Click on the grand total value which will open the underlying data in a new tab “Sheet 1”
(3) Insert a column in the 24th position and write a formula to concatenate the data from 2 other columns.
(4) Create a pivot table from the concatenated data to show the sum of the different products, depending on their ID.
I was able to do 1 & 2 and am stuck on 3 & 4.
Recording would work well, I would think. For some reason, it is not giving the proper results. Thank you!