@victoriaallison7740
Fantastic - exactly what I needed, and the steps made sense. My only comment: even with the correct syntax, I kept getting an error message about the range being too big. I solved this by specifying the actual range (A2:A5075) rather than just the column (A:A). Solved the problem!
@RicardoSenise
Girl, you're genious! Thank you for this masterclass!
@nagendragorli5701
Thank you so much for sharing this great information😊
@namrathamyneni4306
Amazing! never knew life would be much easier. thanks a ton!!!
@kuberravat
क्या बात है रिबेका जी बहुत बढ़िया
@manjotsihra8645
Hi, this is great! This may be a silly question but what can I do when I want to clean the excel and get rid of the original table. This causes problems since the formulas rely on the original table but I want to only keep the new generated table with removed duplicates. Is there a way around this?
@nancyburt1339
I'm following your steps but keep getting a "#Spill!" error. Help! 😢
@gowx
If I had data such as “Red, Yellow” under column shirt for row 1, and “Red” under shirt for row 2, is there a way to separate out “red, yellow” so they are queried as two separate values in a pivot table (meaning that if I am to count the number of ‘reds’, under shirt, it appears as 2x, rather than as “red, yellow” being 1x and “red” being one?) HOWEVER, I’d want to keep the original cell as saying “red, yellow” and not have it be two separate rows… just queried and analyzed as two separate values. Haha thank youuu
@380muller
How to combine multiple rows in to one row in case of numeric data?
@JanineOWilkinsTSSAdminXpress
I have a question not related to this video, but you said to ask! How can I make a list of dates with matching days in another column....but only Monday-Friday ? Is that too easy? I do this every month and think there's got to be an easier way than dragging and then deleting the weekends......🤔
@jaffarmajeed-ic7xz
great but need power query more videos
@manmohansingh4737
A great tutorial although it does not answer what I was looking for. I have an Excel table of BP readings (4 times a day) like this: Date1 Time1 Diastolic1 Systolic1 Pulse1 Date1 Time2 Diastolic2 Systolic2 Pulse2 Date1 Time3 Diastolic3 Systolic3 Pulse3 Date1 Time4 Diastolic4 Systolic4 Pulse4 Date2 Time1 Diastolic1 Systolic1 Pulse1 Date2 Time2 Diastolic2 Systolic2 Pulse2 Date2 Time3 Diastolic3 Systolic3 Pulse3 Date2 Time4 Diastolic4 Systolic4 Pulse4 ... I would like to convert this table into a new table like this: Date1 Time1 Diastolic1 Systolic1 Pulse1 Time2 Diastolic2 Systolic2 Pulse2 Time3 Diastolic3 Systolic3 Pulse3 Time4 Diastolic4 Systolic4 Pulse4 Date2 Time1 Diastolic1 Systolic1 Pulse1 Time2 Diastolic2 Systolic2 Pulse2 Time3 Diastolic3 Systolic3 Pulse3 Time4 Diastolic4 Systolic4 Pulse4 .... Essentially, I want to calculate min, max, and average of columns for different periods of the day to understand the impact of BP medicine and help my doctor better titrate the medicine. Thanks for any hints you can share.
@leightoncolegrave9108
This is very helpful indeed and well presented. However my requirement is similar, but different. My source spreadsheet has 9 rows per unique identifier set with a different named metric and its value in separate columns. My objective is to have one row per identifier set which contains 5 of these metrics in separate columns and a few other columns that contain data that is always the same for an identifier, but not unique by identifier. Example: SOURCE - 9 row per GP practice GP_CODE GP_NAME PCN_NAME ICB_NAME METRIC VALUE D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 CAPABILITY 1 D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 PARTICIPATION 1 D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 RATE_PER_1000 206.6536790049453 D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 TYPE_ADMIN 828 D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 TYPE_CLINICAL 1930 D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 TYPE_OTHER 0 D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 SYSTEM_USAGE 1 D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 TOTAL 2758 D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 REGISTERED 13346 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 CAPABILITY 1 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 PARTICIPATION 1 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 RATE_PER_1000 0.3551451655864334 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 TYPE_ADMIN 4 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 TYPE_CLINICAL 4 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 TYPE_OTHER 0 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 SYSTEM_USAGE 1 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 TOTAL 8 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 REGISTERED 22526 RESULT WANTED - 1 row per GP practice GP_CODE GP_NAME PCN_NAME ICB_NAME RATE_PER_1000 TYPE_ADMIN TYPE_CLINICAL TOTAL REGISTERED D70001 PRACTICE NAME 1 PCN NAME 4 ICB NAME 2 206.6536790049453 828 1930 2758 13346 D70002 PRACTICE NAME 2 PCN NAME 4 ICB NAME 2 0.3551451655864334 4 4 8 22526 How can I achieve this please? Many thanks.
@veruscrt
good！
@AngelsFallFromGrace