Forms populating to column instead of row

[Doc6161]

Hello. My question is regarding info from MS Forms transferring to an Excel sheet. I have the forms set up to populate to a single dedicated sheet. However I am trying to see if there is a way to have it add info to the column of the same person instead of creating a whole new row and having multiples of the same individual. For example when the MS Form is filled out with the ID, name, DOS, and Charge it will go to the excel sheet as such. However what I'm looking to do is to add new info to John Smith's existing row just in the new column (***) as opposed to adding a whole new row.
Any advice is greatly appreciated

ID	CLIENT NAME	DATE OF SERVICE	Charge 1	***
9785	John Smith	2-3-2022	$500
9780	Jane Smith	3-4-2022	$550
9781	Jim Smith	5-6-2022	$560
9782	Joe Smith	6-7-2022	$570
9783	Jack Smith	7-8-2022	$580
9784	Jennifer Smith	8-9-2022	$590

 

[jasonb75]

Do you have any specific reasons for wanting to set it out in that way?

For multiple instances of the same information, multiple rows for the same person is the more normal way of doing things and will be much easier to work with if you need to summarise your data at any point. You should only really use additional columns for different information, for example, to mark the charge as paid.

 

[Doc6161]

Welcome to the Board!

You should be able to use a VLOOKUP function to look up the title of the book from your Working Inventory list, based on the ISBN/ID.
See here for details and examples: Excel formula: VLOOKUP from another sheet | Exceljet

Do you have any specific reasons for wanting to set it out in that way?

For multiple instances of the same information, multiple rows for the same person is the more normal way of doing things and will be much easier to work with if you need to summarise your data at any point. You should only really use additional columns for different information, for example, to mark the charge as paid.

Actually the new columns will have new information. Sorry if I wasn't clear on that in my initial post. And aside from that this is actually a task I'm doing for someone and that's just the way they claim they want it. Not totally sure of their reasoning.

 

[jasonb75]

I'm not sure if it can be done or not, when I first read your question, I thought that you were using an userform, after looking again I had a nagging feeling that I was missing something.
MS Forms is not something that I was aware until of looking it up just now and and as such is something that I have not previously used.

Having a quick look, there may be something of use in this article, I would need a bit of time to set something up and test before being able to make sense of any of it. Hopefully it may mean a bit more to you as you are already using it.

How to sync Microsoft Excel with Microsoft Forms responses (using Power Automate) - Collab365

In this tutorial, I want to demonstrate the following: How to create a form with Microsoft Forms. How to synchronize a Forms response between a Form and Microsoft Excel. If you prefer, you can also watch the video here: If you’ve not used Microsoft Forms, I strongly recommend you take a look at...

collab365.com