The usual format to import and display is: Image attached (Format1)
Wondering if its possible to import data that in (Format2) where there are multiple rows of the same Client ID showing different Room ID's and Rooms
And is it possible to display the data on separate lines or would it have to be displayed in the usual way in one line with commas? Image attached (display)
Once you create repeating field group with your desired fields, you should try to import the data to your repeating field group. But you need to create/prepare the CSV file as per the standard.