• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel layout

Hi

I know how to do this manually that will take me half a day, and not hope it will work.
I am hoping there is a vb script that can help me.
I basically need to change the layout so I can analyze the data.

How to do: The aim is to create one row per OLF# showing all the data. To take the date from the E an F and put in one row.

I have added to tab - the 1st is the current layout and the second- tab- the requested layout.

Excel added to show desired outcome- there are 4 tabs- each with the same request.

You have help me so much in the past. I really appreciate it - you time and effort, and professionalism.

Thank you in advance for any help.
 

Attachments

  • Layout of Excel.xlsx
    47.3 KB · Views: 5
Do you have access to PowerQuery? This type of operation is ideal for it.

If not, this can be done via MS Query. Though it will be bit more complex.

VBA is also possible, but will be more difficult to maintain than above two.

Another method is to set EnableDataValueEditing to True and use code to update a pivottable. I believe @jeffreyweir posted a sample code somewhere. Let me see if I can find it.

Edit: Found it. Thread also has example of how it's done in PowerQuery.
http://stackoverflow.com/questions/...-without-aggregation-to-show-text-not-numbers
 
Last edited:
Hi
I downloaded power query but have no idea how to do it.
Please can you perform and add a file so I can see how you did it.
I tried but no luck
David.
 
Please update your sample workbook with expected output table (column headers and few rows of data).
 
Back
Top