Forum Discussion
Data entry
Hi, I have a datasheet with measuring data named “Measures” Each measure, among other, contains a “Parameters” field as you can see in the following screenshot. The “Parameters” field is a s...
In K2:
=TEXTJOIN(", ";TRUE;IF(Params!$A$2:$A$1000=C2;Params!$B$2:$B$1000&" "&Params!$C$2:$C$1000&" "&Params!$D$2:$D$1000;""))
If the Params sheet has more than 1000 rows of data, adjust the ranges in the formula accordingly.
Then fill down.
Hi,
Thank you for the tip however this is not what I am looking for.
I need an efficient way to enter data into the 'Params" datasheet while viewing the "Measures" datasheet, there is a connection between the two tables using the "Measure" field (the yellow highlighted)
Thank you for the tip however this is not what I am looking for.
I need an efficient way to enter data into the 'Params" datasheet while viewing the "Measures" datasheet, there is a connection between the two tables using the "Measure" field (the yellow highlighted)
- Maybe creating a data type within Power Query would do what you want?
- I am not experienced using Power Query and there are many online courses on this topic.
I cannot decide if any of these fit to my needs.
Any link to specific resource for the above will be greatly appreciated.
