Hi All,
I have company mobile billing report for the last 6 months which contains the following columns:
Column A: Bill Issue Date
Column B: Mobile Number
Column C: Mobile Data Consumption
The mobile number and data consumed value appear for each of the last 6 months.
I need the 'Mobile Data Consumption' reported for each mobile number for the last three months in the following format:
Mobile Number Month 1 Month 2 Month 3 12345 200 500 300 67890 100 800 900
Example spreadsheet attached.
Any help is greatly appreciated!
Bookmarks