Custom Column to sort properly Part2

[jazzista]

Hello Forum : I have a question regarding creating custom columns again. Attached is an operating well statement that I am trying to unpivot and use it in a function to clean 440 well files . Attached is the file that I am trying to transform. Now, I have another challenge which is adding additional columns in order to capture the well production in volumes and values ( Oil, gas ,NGL etc) , the name of the well and total Capex which is a line at the very end.
I think I have done the cleaning part : i just need the final push to clean and transform this table. Attached is the file
Thanks in advance​

 

[Ed Kelly]

Jazzita

Please show me in red on the original report exactly what you want and where you want to see it. Not quite sure of your actual outcome?

 

[jazzista]

Hi Ed: Thanks for your reply. I added another tab for you tosee the desired table that I need: Its basically a skinny table with 5 columns ( See updated file) Thanks in advance .

CONDENSATE VOLUME Well BS54-13-13 - BS-054 13-13(G01452) Volume 5/31/2018 0
CONDENSATE VOLUME Well BS54-13-13 - BS-054 13-13(G01452) Volume 6/30/2018 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 7/31/2017 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 8/31/2017 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 9/30/2017 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 10/31/2017 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 11/30/2017 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 12/31/2017 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 1/31/2018 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 2/28/2018 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 3/31/2018 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 4/30/2018 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 5/31/2018 0
CONDENSATE PRICE Well BS54-13-13 - BS-054 13-13(G01452) Price 6/30/2018 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 7/31/2017 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 8/31/2017 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 9/30/2017 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 10/31/2017 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 11/30/2017 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 12/31/2017 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 1/31/2018 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 2/28/2018 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 3/31/2018 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 4/30/2018 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 5/31/2018 0
CONDENSATE REVENUE Well BS54-13-13 - BS-054 13-13(G01452) Revenue 6/30/2018 0
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 7/31/2017 0
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 8/31/2017 0
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 9/30/2017 36.85
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 10/31/2017 238.85
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 11/30/2017 4.75
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 12/31/2017 0
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 1/31/2018 43.68
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 2/28/2018 13.25
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 3/31/2018 32.71
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 4/30/2018 27.91
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 5/31/2018 33.92
700-5 Consultant Labor Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 6/30/2018 15.76
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 7/31/2017 0
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 8/31/2017 52.29
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 9/30/2017 532.33
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 10/31/2017 2520.94
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 11/30/2017 3540.51
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 12/31/2017 2484.55
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 1/31/2018 3576.92
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 2/28/2018 3205.66
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 3/31/2018 4939.79
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 4/30/2018 1785.65
700-10 Company Labor/Supervsn Well BS54-13-13 - BS-054 13-13(G01452) ROUTINE LOE 5/31/2018 4717.89

 

[Ed Kelly]

Jazzista,

Think this is what you want, if not then give me some feedback and will quickly adjust https://www.screencast.com/t/QabW7BSP

I am assuming with 400+ wells you are going to MS Power BI this puppy to death, on the off chance that you are doing it in Excel added a few very quick pivot tables with charts and slicers that I thought might add a little value. https://www.screencast.com/t/eysEYOB90Bo

Knock 'em Dead Tiger!