Results 1 to 3 of 3

Thread: PQ - How to add columns from a list? each item in a list means a new column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    240
    Rep Power
    8

    Cool

    Result

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    W
    X
    Y
    1
    Financial Statement Main Sub Detailed Sub 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2016V 2017V 2018V 2019V 2020V 2021V 2022V 2023V 2024V 2025V 2026V
    2
    (1) Balance Sheet [1-1] Non Current Assets Fixed assets
    14
    11
    6
    47
    44
    49
    5
    99
    65
    33
    122
    5%
    5%
    3%
    18%
    15%
    25%
    2%
    20%
    -11%
    8%
    55%
    3
    (1) Balance Sheet [1-1] Non Current Assets Investments available for sale
    1
    30
    33
    39
    29
    7
    7
    11
    5
    66
    111
    0%
    13%
    15%
    15%
    10%
    4%
    2%
    2%
    -1%
    17%
    50%
    4
    (1) Balance Sheet [1-1] Non Current Assets intangible assets
    34
    26
    17
    3
    46
    13
    23
    3
    -55
    99
    100
    12%
    12%
    8%
    1%
    15%
    7%
    8%
    1%
    9%
    25%
    45%
    5
    (1) Balance Sheet [1-1] Non Current Assets Deferred tax assets
    51
    43
    25
    16
    40
    8
    31
    49
    -115
    132
    89
    18%
    19%
    11%
    6%
    13%
    4%
    10%
    10%
    19%
    33%
    40%
    6
    (1) Balance Sheet [6-1] Balance Sheet Totals Total non-current assets
    100
    110
    81
    105
    159
    77
    41
    33
    -175
    165
    78
    36%
    49%
    36%
    41%
    53%
    39%
    14%
    7%
    29%
    42%
    35%
    7
    (1) Balance Sheet [2-1] Current Assets Inventory
    37
    48
    45
    42
    52
    31
    14
    42
    -235
    198
    67
    13%
    21%
    20%
    16%
    17%
    16%
    5%
    8%
    39%
    50%
    30%
    8
    (1) Balance Sheet [2-1] Current Assets Cash and the like
    36
    2
    22
    38
    10
    50
    8
    66
    -295
    231
    56
    13%
    1%
    10%
    15%
    3%
    25%
    3%
    13%
    50%
    58%
    25%
    9
    (1) Balance Sheet [2-1] Current Assets Work in progress
    32
    24
    5
    35
    41
    4
    55
    999
    -355
    264
    45
    12%
    11%
    2%
    14%
    14%
    2%
    18%
    200%
    60%
    67%
    20%
    10
    (1) Balance Sheet [2-1] Current Assets Client
    20
    28
    19
    21
    15
    9
    33
    666
    -415
    297
    34
    7%
    13%
    8%
    8%
    5%
    5%
    11%
    133%
    70%
    75%
    15%
    11
    (1) Balance Sheet [2-1] Current Assets Prepaid expenses and other debit balances
    53
    12
    54
    18
    23
    27
    44
    777
    -475
    330
    23
    19%
    5%
    24%
    7%
    8%
    14%
    15%
    155%
    80%
    83%
    10%
    12
    (1) Balance Sheet [6-1] Balance Sheet Totals Total current assets
    178
    114
    145
    154
    141
    121
    50
    111
    -535
    363
    11
    64%
    51%
    64%
    59%
    47%
    61%
    17%
    22%
    90%
    92%
    5%
    13
    (1) Balance Sheet [6-1] Balance Sheet Totals total assets
    278
    224
    226
    259
    300
    198
    300
    500
    -595
    396
    222
    100%
    100%
    100%
    100%
    100%
    100%
    100%
    100%
    100%
    100%
    100%
    Last edited by sandy666; 07-11-2023 at 04:55 AM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. Replies: 7
    Last Post: 08-04-2022, 11:42 AM
  2. Replies: 2
    Last Post: 09-03-2013, 11:00 PM
  3. Replies: 4
    Last Post: 07-27-2013, 01:34 PM
  4. Fetch Nth last item from a list
    By SDruley in forum Excel Help
    Replies: 2
    Last Post: 01-01-2013, 09:28 AM
  5. Add Control to List On Right-Click
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-17-2011, 08:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •