how can I extract the reservations made by one person?

jihenktari 0 Reputation points
2023-02-27T13:06:13.3633333+00:00

Hello, I am trying to sort a table that contains reservations per time slots.
I want to extract each person's reservations in another table.

Thank you in advance for your help!

User's image

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,454 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,526 Reputation points
    2023-02-28T01:55:09.99+00:00

    Hi @jihenktari

    Could you please show us the results that you need?

    Currently, I would suggest you import the table into Power Query and transform the data.

    • Select the table, then go to Data tab > Get & Transform Data group > From Table/Range. Capture63
    • Press Ctrl key to select other columns except Slot, such as Amazon, airbnb, tesla and .etc > go to Transform tab > Any Column group > Unpivot Columns. Capture64
    • Select the Value column > go to Transform tab > Any Column group > Pivot Column. Choose the Attribute as Values Column, and select Don't Aggregate. Capture65
    • We will get the table as following image. Capture66
    • Please click Home tab > Close & Load to > Select the cell that you want to put this table. Capture67

    Any misunderstandings, please post back.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.