Hello Experts,
I have a Pivot table created from a realtime data source in "Pviot_Data" tab.
Each row in the Pivot will have be in this format:
Text1-Num1-Text2-Text3
I am trying to extract:
1. Text1 & Text3 in 'Pivot_Data' tab into separate Columns in 'Extracted_Data' tab. (Done)
2. Need to extract '2018 Total' in 'Pivot_Data' tab into "respective" 'Spend till Date' Columns in 'Extracted_Data' tab.
Note: Customer (or Text1) will always be unique.
In Summary, I am trying to look up Customer from 'Extracted_Data' tab in Col-B of 'Pivot_Data' tab & return the last Col value of 'Pivot_Data' always.
Hope I was able to explain myself.
Thank you in anticipation.
Best Regs
Seskhar
I have a Pivot table created from a realtime data source in "Pviot_Data" tab.
Each row in the Pivot will have be in this format:
Text1-Num1-Text2-Text3
I am trying to extract:
1. Text1 & Text3 in 'Pivot_Data' tab into separate Columns in 'Extracted_Data' tab. (Done)
2. Need to extract '2018 Total' in 'Pivot_Data' tab into "respective" 'Spend till Date' Columns in 'Extracted_Data' tab.
Note: Customer (or Text1) will always be unique.
In Summary, I am trying to look up Customer from 'Extracted_Data' tab in Col-B of 'Pivot_Data' tab & return the last Col value of 'Pivot_Data' always.
Hope I was able to explain myself.
Thank you in anticipation.
Best Regs
Seskhar