Forum

lea cohen
@usb
Honorable Member
Joined: Mar 10, 2016
Topics: 129 / Replies: 115
Reply
RE: Unpivot a file with 2 titles

I had an idea - I set row 6 - where the data changes to a header row I added after the number which is 5 digits - _the name of the column The column n...

4 years ago
Forum
Reply
RE: Unpivot a file with 2 titles

With your permission, I sharpen the question The file I made here is just a sample of my large file The updated demo file is attached here What's Happ...

4 years ago
Forum
Reply
RE: Interim Summaries in Excel's Smart Table

In the sample attachment- It must remain a smart dynamic table Because it is based on Power Query I need an interim summary for each solarSystem To do...

4 years ago
Reply
RE: Unpivot a file with 2 titles

Dear Minda, Thank you very much !!!!!!!!! You helped me a lot !!!! Very appreciative, Leah

4 years ago
Forum
Reply
RE: Unpivot a file with 2 titles

I'm doing what you wrote Receives an ERROR message to all cells It is also not clear to me whether UNPIVOT should be done I would be very grateful if ...

4 years ago
Forum
Reply
RE: Unpivot a file with 2 titles

This - highlighted in yellow Row 3 - should be the title Thanks for the answer Leah

4 years ago
Forum
Topic
Forum
Replies: 9
Views: 214
Reply
Reply
RE: Problem with hours summary

The hours here are retrieved with a formula from another file. Here is the original file of the hours I received from the software. I tried in Powe...

4 years ago
Topic
Replies: 5
Views: 192
Reply
RE: Problem changing file in folder after Query

Thanks for the detailed answer! I did check and the name of the issue in both was not the same- There was a small change I had not noticed before. Tha...

5 years ago
Forum
Reply
RE: Problem changing file in folder after Query

hi, As for the error, how can the column labels be incorrect? I downloaded from the system to Excel 2 files with a fixed structure - only the data is ...

5 years ago
Forum
Page 9 / 17