• 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.

place text corresponding to colums in the specific rows required

need help to place formulas in the specific rows so that I can use pivot.
if there is macro available

upload_2017-1-16_11-13-32.png
 

Attachments

  • problem1.xlsx
    14.9 KB · Views: 9
Is there anyway I can use formula or macro to make them look like this. With the profit center to line on the left column next to the time, instead of being the header.

upload_2017-1-16_19-56-27.png
 

Attachments

  • upload_2017-1-16_19-55-53.png
    upload_2017-1-16_19-55-53.png
    135.7 KB · Views: 2
Is there anyway I can use formula or macro to make them look like this. With the profit center to line on the left column next to the time, instead of being the header.

View attachment 37483
Hi,

Please refer to attachment
Using column "A" as a helper column and INDEX formula in Column "B".

Hope this helps
 

Attachments

  • problem1.xlsx
    18.5 KB · Views: 6
Back
Top