Transpose data from one sheet to other in particular format - AUD $20

  • Re: Transpose data from one sheet to other in particular format - AUD $20


    also just the output 1 format is not right, there are 4 rows created instead of one


    [TABLE="width: 552"]

    [tr]


    [TD="class: xl67, width: 92, bgcolor: transparent"]Date
    [/TD]
    [TD="class: xl68, width: 92, bgcolor: transparent"]Time
    [/TD]
    [TD="class: xl69, width: 92, bgcolor: transparent"]Import kWh
    [/TD]
    [TD="class: xl69, width: 92, bgcolor: transparent"]import kVArh
    [/TD]
    [TD="class: xl69, width: 92, bgcolor: transparent"]Export kWh
    [/TD]
    [TD="class: xl69, width: 92, bgcolor: transparent"]Export kVArh
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl69, bgcolor: transparent"]19/05/2015
    [/TD]
    [TD="class: xl68, bgcolor: transparent, align: right"]12:30 AM
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent, align: right"]21
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="class: xl69, bgcolor: transparent"]19/05/2015
    [/TD]
    [TD="class: xl68, bgcolor: transparent, align: right"]12:30 AM
    [/TD]
    [TD="class: xl69, bgcolor: transparent, align: right"]21.112
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="class: xl69, bgcolor: transparent"]19/05/2015
    [/TD]
    [TD="class: xl68, bgcolor: transparent, align: right"]12:30 AM
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent, align: right"]42
    [/TD]

    [/tr]


    [tr]


    [TD="class: xl69, bgcolor: transparent"]19/05/2015
    [/TD]
    [TD="class: xl68, bgcolor: transparent, align: right"]12:30 AM
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent, align: right"]10.476
    [/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]
    [TD="class: xl69, bgcolor: transparent"][/TD]

    [/tr]


    [/TABLE]


    this should show as below:



    [TABLE="width: 474"]

    [tr]


    [td]

    Date

    [/td]


    [td]

    Time

    [/td]


    [td]

    Import kWh

    [/td]


    [td]

    import kVArh

    [/td]


    [td]

    Export kWh

    [/td]


    [td]

    Export kVArh

    [/td]


    [/tr]


    [tr]


    [td]

    19/05/2015

    [/td]


    [TD="align: right"]12:30 AM[/TD]
    [TD="align: right"]21.112[/TD]
    [TD="align: right"]10.476[/TD]
    [TD="align: right"]21[/TD]
    [TD="align: right"]42[/TD]

    [/tr]


    [/TABLE]

  • Re: Transpose data from one sheet to other in particular format - AUD $20


    Is your Output Date column formatted as Date?


    What date system are you using, mm/dd/yyyy or dd/mm/yyyy?

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: Transpose data from one sheet to other in particular format - AUD $20


    New version of the file sent by e-mail.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!