How do I add/insert a column that contains the number 1 for all the excel lines ? If there are 100 lines, I want to insert a column containg the number 1 in each of the 100 lines.
How do I add/insert a column that contains the number 1 for all the excel lines ? If there are 100 lines, I want to insert a column containg the number 1 in each of the 100 lines.
Simplest way: Enter 1 in cell A1. Copy. Select range A2:A100. Paste.
Is 100 rows your actual requirement, or are you going to reply and say "That's great, but what I really want is 374,000 rows?!" :D
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks